class CreateSlideshares < ActiveRecord::Migration
  def self.up
    create_table :slideshares do |t|
      t.string :slideshow_id
      t.string :title
      t.text :description
      t.string :status
      t.string :username
      t.string :url
      t.string :thumbnail_url
      t.string :thumbnail_small_url
      t.string :embed
      t.string :created
      t.integer :upload_day
      t.integer :upload_month
      t.integer :upload_year
      t.string :language
      t.string :format
      #array of tags
      t.string :tags
      t.string :number_of_downloads
      t.string :number_of_views
      t.string :number_of_comments
      t.string :number_of_favorites
      t.string :number_of_slides
      #array of slideshow ids
      t.string :related_slideshows
      t.references :tag

      t.timestamps
    end
  end

  def self.down
    drop_table :slideshares
  end
end
